Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Document Date' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DOCUMENT DATE

Seq No	Page Number	Page Name	Control Name
1	25	Customer Ledger Entries	Document Date
2	29	Vendor Ledger Entries	Document Date
3	39	General Journal	Document Date
4	40	Item Journal	Document Date
5	41	Sales Quote	Document Date
6	42	Sales Order	Document Date
7	43	Sales Invoice	Document Date
8	44	Sales Credit Memo	Document Date
9	45	Sales List	Document Date
10	49	Purchase Quote	Document Date
11	50	Purchase Order	Document Date
12	51	Purchase Invoice	Document Date
13	52	Purchase Credit Memo	Document Date
14	123	VAT Entries Preview	Document Date
15	130	Posted Sales Shipment	Document Date
16	132	Posted Sales Invoice	Document Date
17	134	Posted Sales Credit Memo	Document Date
18	136	Posted Purchase Receipt	Document Date
19	138	Posted Purchase Invoice	Document Date
20	140	Posted Purchase Credit Memo	Document Date
21	142	Posted Sales Shipments	Document Date
22	143	Posted Sales Invoices	Document Date
23	144	Posted Sales Credit Memos	Document Date
24	145	Posted Purchase Receipts	Document Date
25	146	Posted Purchase Invoices	Document Date
26	147	Posted Purchase Credit Memos	Document Date
27	189	Incoming Document	Document Date
28	189	Incoming Document	Document Date
29	190	Incoming Documents	Document Date
30	201	Job Journal	Document Date
31	207	Resource Journal	Document Date
32	253	Sales Journal	Document Date
33	254	Purchase Journal	Document Date
34	255	Cash Receipt Journal	Document Date
35	256	Payment Journal	Document Date
36	283	Recurring General Journal	Document Date
37	286	Recurring Item Jnl.	Document Date
38	289	Recurring Job Jnl.	Document Date
39	290	Recurring Resource Jnl.	Document Date
40	315	VAT Entries	Document Date
41	392	Phys. Inventory Journal	Document Date
42	393	Item Reclass. Journal	Document Date
43	434	Reminder	Document Date
44	435	Reminder Lines	Document Date
45	438	Issued Reminder	Document Date
46	439	Issued Reminder Lines	Document Date
47	446	Finance Charge Memo	Document Date
48	447	Finance Charge Memo Lines	Document Date
49	450	Issued Finance Charge Memo	Document Date
50	451	Issued Fin. Charge Memo Lines	Document Date
51	507	Blanket Sales Order	Document Date
52	509	Blanket Purchase Order	Document Date
53	519	Item Journal Lines	Document Date
54	610	IC General Journal	Document Date
55	611	IC Outbox Transactions	Document Date
56	613	Handled IC Outbox Transactions	Document Date
57	615	IC Inbox Transactions	Document Date
58	617	Handled IC Inbox Transactions	Document Date
59	636	IC Outbox Sales Doc.	Document Date
60	638	IC Outbox Purchase Doc.	Document Date
61	640	Handled IC Outbox Sales Doc.	Document Date
62	642	Handled IC Outbox Purch. Doc.	Document Date
63	644	IC Inbox Sales Doc.	Document Date
64	646	IC Inbox Purchase Doc.	Document Date
65	648	Handled IC Inbox Sales Doc.	Document Date
66	650	Handled IC Inbox Purch. Doc.	Document Date
67	1020	Job G/L Journal	Document Date
68	1232	Positive Pay Entry Details	Document Date
69	1272	OCR Data Correction	Document Date
70	1572	VAT Entries Preview Subform	Document Date
71	1575	VAT Entries Preview Flat Subf.	Document Date
72	1602	Office Document Selection	Document Date
73	1602	Office Document Selection	Document Date
74	1690	Bank Deposit	Document Date
75	1692	Bank Deposits	Document Date
76	1693	Bank Deposit Subform	Document Date
77	1694	Posted Bank Deposit	Document Date
78	1695	Posted Bank Deposit Lines	Document Date
79	1696	Posted Bank Deposit List	Document Date
80	1697	Posted Bank Deposit Subform	Document Date
81	2103	O365 Sales Document List	Document Date
82	2109	O365 Customer Sales Documents	Document Date
83	2110	O365 Sales Invoice	Document Date
84	2113	O365 Posted Sales Invoice	Document Date
85	2190	O365 Invoicing Sales Doc. List	Document Date
86	2310	BC O365 Sales Invoice	Document Date
87	2313	BC O365 Posted Sales Invoice	Document Date
88	5159	Sales Order Archive	Document Date
89	5162	Sales Quote Archive	Document Date
90	5164	Purchase Quote Archive	Document Date
91	5167	Purchase Order Archive	Document Date
92	5510	Production Journal	Document Date
93	5628	Fixed Asset G/L Journal	Document Date
94	5802	Value Entries	Document Date
95	5803	Revaluation Journal	Document Date
96	5807	Value Entries Preview	Document Date
97	5900	Service Order	Document Date
98	5933	Service Invoice	Document Date
99	5935	Service Credit Memo	Document Date
100	5964	Service Quote	Document Date
101	5972	Posted Service Credit Memo	Document Date
102	5974	Posted Service Shipments	Document Date
103	5975	Posted Service Shipment	Document Date
104	5977	Posted Service Invoices	Document Date
105	5978	Posted Service Invoice	Document Date
106	6121	E-Document	Document Date
107	6121	E-Document	Document Date
108	6122	E-Documents	Document Date
109	6561	Invt. Receipt	Document Date
110	6563	Invt. Receipts	Document Date
111	6564	Invt. Shipment	Document Date
112	6566	Invt. Shipments	Document Date
113	6567	Posted Invt. Receipt	Document Date
114	6569	Posted Invt. Receipts	Document Date
115	6570	Posted Invt. Shipment	Document Date
116	6572	Posted Invt. Shipments	Document Date
117	6620	Blanket Sales Order Archive	Document Date
118	6623	Blanket Purchase Order Archive	Document Date
119	6627	Sales Return Order Archive	Document Date
120	6630	Sales Return Order	Document Date
121	6640	Purchase Return Order	Document Date
122	6644	Purchase Return Order Archive	Document Date
123	6650	Posted Return Shipment	Document Date
124	6652	Posted Return Shipments	Document Date
125	6660	Posted Return Receipt	Document Date
126	6662	Posted Return Receipts	Document Date
127	6774	Invt. Document Lines	Document Date
128	6775	Invt. Document List	Document Date
129	6873	Available – Invt. Doc. Lines	Document Date
130	9300	Sales Quotes	Document Date
131	9301	Sales Invoice List	Document Date
132	9302	Sales Credit Memos	Document Date
133	9304	Sales Return Order List	Document Date
134	9305	Sales Order List	Document Date
135	9306	Purchase Quotes	Document Date
136	9307	Purchase Order List	Document Date
137	9308	Purchase Invoices	Document Date
138	9309	Purchase Credit Memos	Document Date
139	9311	Purchase Return Order List	Document Date
140	9317	Service Quotes	Document Date
141	9318	Service Orders	Document Date
142	9319	Service Invoices	Document Date
143	9320	Service Credit Memos	Document Date
144	9346	Purchase Quote Archives	Document Date
145	9347	Purchase Order Archives	Document Date
146	9348	Sales Quote Archives	Document Date
147	9349	Sales Order Archives	Document Date
148	41002	Hist. Sales Trx. Headers	Document Date
149	41006	Hist. Receivables Document	Document Date
150	41006	Hist. Receivables Document	Document Date
151	41007	Hist. Sales Trx.	Document Date
152	41008	Hist. Payables Document	Document Date
153	41008	Hist. Payables Document	Document Date
154	41010	Hist. Inventory Trx.	Document Date
155	41012	Hist. Inventory Trx. Headers	Document Date
156	41016	Hist. Receivables Documents	Document Date
157	41017	Hist. Payables Documents	Document Date
158	99000773	Capacity Journal	Document Date
159	99000778	Recurring Capacity Journal	Document Date
160	99000823	Output Journal	Document Date
161	99000827	Recurring Output Journal	Document Date
162	99000846	Consumption Journal	Document Date
163	99000850	Recurring Consumption Journal	Document Date

Dynamics 365 BC Table ReferencePage Control Search